##开启事务
BEGIN;
SET NAMES utf8mb4;

-- ------------------------> 正式开始写 SQL 语句 <------------------------
ALTER TABLE `hair_salon`.`top_up_bill`
    ADD COLUMN `gift_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '赠送金额' AFTER `top_up_price`;
ALTER TABLE `hair_salon`.`member_info`
    ADD COLUMN `gift_balance` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '赠送余额' AFTER `balance`;
ALTER TABLE `hair_salon`.`expense_bill`
    ADD COLUMN `gift_price` decimal(10, 2) NULL COMMENT '赠送金额' AFTER `final_price`;

ALTER TABLE `hair_salon`.`top_up_bill`
    ADD INDEX `member_id_index` (`member_id`) USING BTREE;
ALTER TABLE `hair_salon`.`member_info`
    ADD INDEX `member_no_index` (`member_no`) USING BTREE,
    ADD INDEX `member_name_index` (`member_name`) USING BTREE,
    ADD INDEX `member_phone_index` (`member_phone`) USING BTREE;
ALTER TABLE `hair_salon`.`expense_bill`
    ADD INDEX `member_id_index` (`member_id`) USING BTREE;
-- ------------------------> 正式结束写 SQL 语句 <------------------------
##提交事务
COMMIT;

## 如遇错误, 执行以下sql
## ROLLBACK;